<?php

$month_date = $route->bodyParams['month_date'];
$os_id = $route->bodyParams['os_id'];

$sql = "SELECT FROM_UNIXTIME(osctc_create_time,'%Y-%m') as check_time_date,count(*) as month_count FROM art_organization_erp.art_oa_student_class_time_check where FROM_UNIXTIME(osctc_create_time,'%Y-%m') = '".$month_date."' and osctc_osid = '".$os_id."' and osctc_status = '0' group by check_time_date";

$re=$db->mysqlDB->query($sql);

$response->responseData(true,$re);